<%-- 
    Document   : mem_details
    Created on : Oct 7, 2009, 3:36:00 AM
    Author     : bharath
--%>
<%@ page import="java.io.* ,java.util.*, java.sql.*, Login.* , javax.servlet.http.* , Registration.* " %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
        <title>SCF - Who's Who</title>
		<link href="../style.css" rel="stylesheet" type="text/css" />
        <style type="text/css">
<!--
.style1 {color: #FFFFFF}
.style2 {font-size: 16px}
.style3 {
	font-size: 18px;
	color: #FFFFFF;
}
-->
        </style>
		<script>
		function MatSearch()
		{
		Location = "Matrimonial/MatSearchMembers1.jsp" ;
		}
		</script>
</head>
<% 
HttpSession hs = request.getSession(true);
String id = (String) hs.getAttribute("memid");
 
MySqlConnector ms = new MySqlConnector();
PreparedStatement stmt, stmt1;
ResultSet rs, rs1 ;
Connection con = ms.Connect();
// All members
String q = "SELECT memberid , name , surname , matchfor , mname , msname , mage , mobile , mqual, mprof " +
        "FROM registration, mar_reg where registration.memberid = mar_reg.memid ";
stmt = con.prepareStatement(q);
stmt1 = con.prepareStatement("Select distinct(mqual) from mar_reg");
rs = stmt.executeQuery();
rs1 = stmt1.executeQuery();
%>
<body>

   <a href = "MatrUserHome.jsp">BACK</a>
    <h1 align="left" class="style1"><span class="style8">Welcome :</span> <%=id%></h1>
    <form action="../ViewMatMember" method="post" name="form1" id="form1">
      <table width="886" height="112"  border="1" align="center" bordercolor="#FFFFFF" class="greenlink_no_left_padding">
        <tr>
          <th height="30" colspan="4" bgcolor="#333333"><h2 align="left" class="style2">Member Search </h2></th>
        </tr>

        <tr bordercolor="#000000">
          <th width="250" nowrap="nowrap" class="greentext">Search For  : <span class="style7">
            <select name="gender" id="gender">
			<option> </option>
			<option value = "Female"> Bride </option>
			<option value = "Male"> Bride-Groom</option>
			</select>
          </span></th>
          <th width="105" nowrap="nowrap" class="style7"><span class="greentext">Age : 
              <input name="age" type="text" id="age"  size="5"/>
          </span></th>
          <th width="266" nowrap="nowrap" class="style7"><span class="greentext">Qualification:
              <select name="qual" id="qual" >
<%			  while (rs1.next()==true)
				{ %>
			  <option><%=rs1.getString(1)%></option>
			  <% } %> 
                    <!--<option value="">Please select</option>
                    <optgroup label="&nbsp;"></optgroup>
                    <optgroup label="Professional Degrees">
                    <option >BAMS</option>
                    <option >BHMS</option>
                    <option >B.E/B.Tech</option>
                    <option >B.Pharma</option>
                    <option >CA</option>
                    <option >CS</option>
                    <option >DM</option>
                    <option >ICWA</option>
                    <option >MBBS/BDS</option>
                    <option >MCA/PGDCA</option>
                    <option >MD/MS (Medical)</option>
                    <option >M.E/M.Tech/MS (Engg.)</option>
                    <option >M.Pharma</option>
                    <option >Ph. D</option>
                    </optgroup>
                    <optgroup label="&nbsp;"></optgroup>
                    <optgroup label="Post-Graduate Degrees">
                    <option >M.A</option>
                    <option >M.Com</option>
                    <option >M.Sc</option>
                    <option >MBA/PGDM</option>
                    <option >ML/LLM</option>
                    </optgroup>
                    <optgroup label="&nbsp;"></optgroup>
                    <optgroup label="Graduate Degrees">
                    <option>B.A</option>
                    <option >B.Com</option>
                    <option >B.Sc</option>
                    <option >BL/LLB</option>
                    </optgroup>
                    <optgroup label="&nbsp;"></optgroup>
                    <optgroup label="&nbsp;"></optgroup>
                    <option >High School</option>
                    <option >Trade School</option>
                    <option >Diploma</option>
                    <option >Other</option> 
					-->
          </select>
        </span></th>
          <th width="237" nowrap="nowrap" class="style7"><span class="greentext">
     <input  name="MatSearch" type="submit" class="redtext" id="MatSearch" value="Matrimony Search" />
        </span></th>
        </tr>

        <tr>
          <th height="30" colspan="4" bordercolor="#000000" bgcolor="#333333"><div align="center">
            <pre class="style3">Member Details </pre>
          </div></th>
        </tr>
        <tr>
          <th height="30" colspan="4" bordercolor="#000000" bgcolor="#333333" class="style1"><div align="center">
            <h1>&nbsp;</h1>
            <p align="left" class="whitetext">
              <input name="ViewMem" type="submit" class="bluetext" id="ViewMem" value="View Full Details" />
            Click to see full details of a bride / bride-groom </p>
          </div></th>
        </tr>
        <tr>
          <th height="30" colspan="4" bordercolor="#000000" bgcolor="#333333" class="greenlink">
              <table width="100%" border="0" cellpadding="0" cellspacing="0" class="greenlink_no_left_padding">
            <tr>
              <td width="4%" class="redtext">&nbsp;</td>
              <td width="16%" class="redtext">SCF MEM NAME </td>
              <td width="12%" class="redtext">MOBILE</td>
              <td width="11%" class="redtext">RELATION</td>
              <td width="15%" class="redtext">NAME</td>
              <td width="11%" class="redtext">AGE</td>
              <td width="17%" class="redtext">QUALIFICATION</td>
              <td width="14%" class="redtext">PROFESSION</td>
            </tr>
            <tr>
               <% while(rs.next()==true)
	{  %>
            <td><input name="rcheck" type="radio"  value="<%=rs.getString(1)%>"/></td>
              <td><%=rs.getString(2) %>. <%=rs.getString(3)%></td>
              <td><%=rs.getString(8)%></td>
              <td><%=rs.getString(4)%> </td>
              <td><%=rs.getString(5) %>.<%=rs.getString(6)%></td>
              <td><%=rs.getString(7)%></td>
              <td><%=rs.getString(9)%></td>
              <td><%=rs.getString(10)%></td>
            </tr>
	<% } %>
          </table></th>
        </tr>
        <tr class="greentext">
          <th height="2" colspan="4" class="style7"></th>
        </tr>
      </table>
    </form>
	
</body>
</html>

